Function returning number of characters in text: A. COUNT B. LEN C. MID D. CHAR Correct answer is: B. LEN 📖 Read Detailed Explanation → Computer Science MCQS FPSC Information Technology Mcqs Leave a Comment | Umar
A chart on a separate sheet is called: A. Embedded Chart B. Chart Sheet C. Graph Sheet D. Pivot Chart Correct answer is: B. Chart Sheet 📖 Read Detailed Explanation → Computer Science MCQS FPSC Information Technology Mcqs Leave a Comment | Umar
Shortcut to apply/remove strikethrough: A. Ctrl + 5 B. Ctrl + 4 C. Ctrl + 2 D. Ctrl + 1 Correct answer is: A. Ctrl + 5 📖 Read Detailed Explanation → Computer Science MCQS FPSC Information Technology Mcqs Leave a Comment | Umar
Feature that fills cells automatically based on pattern: A. AutoComplete B. AutoFill C. AutoCorrect D. Flash Fill Correct answer is: B. AutoFill 📖 Read Detailed Explanation → Computer Science MCQS FPSC Information Technology Mcqs Leave a Comment | Umar
Which of the following is a valid mixed cell reference? A. $A$1 B. A1 C. $A1 D. $1A Correct answer is: C. $A1 📖 Read Detailed Explanation → Computer Science MCQS FPSC Information Technology Mcqs Leave a Comment | Umar
Number of rows in Excel 2007+: A. 65,536 B. 1,048,576 C. 16,384 D. 99,999 Correct answer is: B. 1,048,576 📖 Read Detailed Explanation → Computer Science MCQS FPSC Information Technology Mcqs Leave a Comment | Umar
Number of columns in Excel 2007+: A. 256 B. 65,536 C. 16,384 D. 1,048,576 Correct answer is: C. 16,384 📖 Read Detailed Explanation → Computer Science MCQS FPSC Information Technology Mcqs Leave a Comment | Umar
Function to look up value in first column of a table: A. HLOOKUP B. LOOKUP C. VLOOKUP D. FIND Correct answer is: C. VLOOKUP 📖 Read Detailed Explanation → Computer Science MCQS FPSC Information Technology Mcqs Leave a Comment | Umar
Which function finds current date? A. TIME B. DATE C. TODAY() D. NOW() Correct answer is: C. TODAY() 📖 Read Detailed Explanation → Computer Science MCQS FPSC Information Technology Mcqs Leave a Comment | Umar
Which function counts cells containing numbers? A. COUNT B. COUNTA C. COUNTBLANK D. SUM Correct answer is: A. COUNT 📖 Read Detailed Explanation → Computer Science MCQS FPSC Information Technology Mcqs Leave a Comment | Umar
Rows in Excel are labeled with: A. Letters B. Symbols C. Numbers D. Roman numerals Correct answer is: C. Numbers 📖 Read Detailed Explanation → Computer Science MCQS FPSC Information Technology Mcqs Leave a Comment | Umar
Columns in Excel are labeled with: A. Numbers B. Letters C. Symbols D. Both letters and numbers Correct answer is: B. Letters 📖 Read Detailed Explanation → Computer Science MCQS FPSC Information Technology Mcqs Leave a Comment | Umar
The small green square used to copy formulas to adjacent cells is the: A. Copy handle B. Fill Handle C. Drag handle D. Insert handle Correct answer is: B. Fill Handle 📖 Read Detailed Explanation → Computer Science MCQS FPSC Information Technology Mcqs Leave a Comment | Umar
Which function calculates the average of numbers? A. SUM B. COUNT C. AVERAGE D. TOTAL Correct answer is: C. AVERAGE 📖 Read Detailed Explanation → Computer Science MCQS FPSC Information Technology Mcqs Leave a Comment | Umar
The intersection of a column and a row is called a: A. Cell B. Sheet C. Box D. Tab Correct answer is: A. Cell 📖 Read Detailed Explanation → Computer Science MCQS FPSC Information Technology Mcqs Leave a Comment | Umar
Which function would you use to find the largest number in a range? A. MIN B. MAX C. LARGE D. COUNT Correct answer is: B. MAX 📖 Read Detailed Explanation → Computer Science MCQS FPSC Information Technology Mcqs Leave a Comment | Umar
What does the symbol $ represent in a cell reference like $A$1? A. A relative reference B. A text string C. An absolute reference D. A currency value Correct answer is: C. An absolute reference 📖 Read Detailed Explanation → Computer Science MCQS FPSC Information Technology Mcqs Leave a Comment | Umar
Which function is used to add a range of cells? A. AVERAGE B. SUM C. ADD D. TOTAL Correct answer is: B. SUM 📖 Read Detailed Explanation → Computer Science MCQS FPSC Information Technology Mcqs Leave a Comment | Umar
In Excel, a combination of a column letter and a row number (e.g., A1 or B4) is called a: A. Cell Address / Cell Reference B. Cell Pointer C. Range D. Formula Correct answer is: A. Cell Address / Cell Reference 📖 Read Detailed Explanation → Computer Science MCQS FPSC Information Technology Mcqs Leave a Comment | Umar
What is the default file extension for an Excel 2016 workbook? A. .docx B. .pptx C. .xlsx D. .xls Correct answer is: C. .xlsx 📖 Read Detailed Explanation → Computer Science MCQS FPSC Information Technology Mcqs Leave a Comment | Umar
A file in MS Excel is known as a: A. Document B. Slide C. Workbook D. Worksheet Correct answer is: C. Workbook 📖 Read Detailed Explanation → Computer Science MCQS FPSC Information Technology Mcqs Leave a Comment | Umar
In PowerPoint, a .wav file is a type of: A. Video file B. Image file C. Sound file D. Presentation file Correct answer is: C. Sound file 📖 Read Detailed Explanation → Computer Science MCQS FPSC Information Technology Mcqs Leave a Comment | Umar
The area at the bottom of a slide where you can place repeating information like a date is called the: A. Header B. Footer C. Margin D. Endnote Correct answer is: B. Footer 📖 Read Detailed Explanation → Computer Science MCQS FPSC Information Technology Mcqs Leave a Comment | Umar
The individual effects applied to text or objects on a slide are called: A. Transitions B. Animations C. Schemes D. Presets Correct answer is: B. Animations 📖 Read Detailed Explanation → Computer Science MCQS FPSC Information Technology Mcqs Leave a Comment | Umar
By default, slides in a PowerPoint presentation are oriented in which layout? A. Portrait B. Landscape C. Thumbnail D. Wide Correct answer is: B. Landscape 📖 Read Detailed Explanation → Computer Science MCQS FPSC Information Technology Mcqs Leave a Comment | Umar