EXCEL EXAM | QUESTIONS AND VERIFIED ANSWERS| 100%| LATEST 2024/ 2025

EXCEL EXAM | QUESTIONS AND VERIFIED ANSWERS| 100%| LATEST 2024/ 2025


By default, how does Excel align numeric entries in a cell?

A. top left corner of a cell

B. top right corner of a cell

C. bottom left corner of a cell

D. bottom right corner of a cell - ✔✔D: Bottom right corner of a cell



Which of the following commands lets you display a label on multiple lines within a cell?

A. Split

B. Merge & Center

C. Wrap Text

D. Format Painter - ✔✔C: Wrap Text



Which of the following Page Setup options lets you set margins for headers and footers?

A. Page

B. Margins

C. Header/Footer

D. Sheet - ✔✔B: Margins



Once you have saved a workbook for the first time, which of the following keyboard shortcuts can you
use to save it again?

A. Ctrl+F

B. Ctrl+K

C. Ctrl+R

D. Ctrl+S - ✔✔D: Ctrl + S



What is selected when you click the Select All button located above the row 1 heading and to the left of
the column A heading?

, A. the entire column

B. the entire row

C. the entire worksheet

D. the 20 cells adjacent to the top of the column - ✔✔C: The entire worksheet



What is selected when you point to and click a column heading?

A. the entire column

B. the entire row

C. the entire worksheet

D. the 20 cells adjacent to the top of the column - ✔✔A: The entire column



Which of the following Spelling dialog box options skips all occurrences of the same spelling of a word in
the worksheet?

A. Ignore Once

B. Ignore All

C. Change

D. Change All - ✔✔B: Ignore all



Which of the following describes the section of the worksheet that prints?

A. gridline area

B. zoom area

C. fill area

D. print area - ✔✔D: Print area



Which of the following displays in a cell when you click AutoSum?

A. =SUM ()

B. =AUTOSUM

C. =ADD

D. =AUTOADD - ✔✔A: =SUM ()