CORRECT ANSWERS (VERIFIED ANSWERS) Q&A
2027 |INSTANT DOWNLOAD PDF
1. What is Microsoft Excel primarily used for?
A. Editing videos B. Creating spreadsheets and analyzing data C.
Designing websites D. Recording audio
Correct answer: B. Creating spreadsheets and analyzing data
Rationale: Excel is a spreadsheet application used to organize,
calculate, analyze, and visualize information.
2. What is an Excel workbook?
A. A single cell B. A collection of worksheets C. A formula D. A
chart
Correct answer: B. A collection of worksheets
Rationale: A workbook is an Excel file that can contain multiple
worksheets.
3. What is a worksheet in Excel?
A. A page containing rows and columns B. A computer folder C.
A presentation slide D. A database server
Correct answer: A. A page containing rows and columns
Rationale: A worksheet is the working area where users enter
and manage spreadsheet data.
,4. What is the intersection of a row and a column called?
A. Table B. Range C. Cell D. Workbook
Correct answer: C. Cell
Rationale: A cell is the basic unit of a worksheet where data is
entered.
5. Which symbol identifies a column in Excel?
A. Numbers B. Letters C. Special characters D. Roman numerals
Correct answer: B. Letters
Rationale: Excel columns are identified by letters such as A, B,
C, and D.
6. How are rows identified in Excel?
A. Letters B. Symbols C. Numbers D. Colors
Correct answer: C. Numbers
Rationale: Rows are numbered sequentially, starting with 1.
7. What is the name of the first cell in an Excel worksheet?
A. B1 B. A1 C. A2 D. C1
Correct answer: B. A1
Rationale: Cell A1 is located at the intersection of the first
column and first row.
8. Which file extension is commonly used for modern Excel
workbooks?
,A. .docx B. .pptx C. .xlsx D. .txt
Correct answer: C. .xlsx
Rationale: The .xlsx extension is the standard format for
modern Excel workbooks.
9. Which keyboard shortcut saves an Excel workbook?
A. Ctrl + S B. Ctrl + P C. Ctrl + C D. Ctrl + X
Correct answer: A. Ctrl + S
Rationale: Ctrl + S saves changes made to the current
workbook.
10. What is the Formula Bar used for?
A. Changing computer settings B. Viewing and editing cell
contents or formulas C. Printing worksheets D. Opening
websites
Correct answer: B. Viewing and editing cell contents or
formulas
Rationale: The Formula Bar displays the contents of the
selected cell and allows editing.
11. Which character must generally begin an Excel formula?
A. # B. @ C. = D. &
Correct answer: C. =
Rationale: Excel recognizes an expression as a formula when it
begins with an equals sign.