Question: 6
To displays the Find and Replace dialog box, with the Find tab selected press
(A) Alt + F
(B) Tab + F
(C) Esc + F
(D) Ctrl + F
Ans: D
Ctrl + F
Question: 7
Press ______ to displays the format cell dialog box in MS Excel.
(A) Ctrl + 1
(B) Ctrl + 2
(C) Ctrl + 3
(D) Ctrl + 4
Ans: A
Ctrl + 1
Question: 8
Pre-defined and built in formulas in Excel are known as
(A) Autosheets
(B) Charts
(C) Functions
(D) Tables
Ans: C
Functions
Question: 9
Press ______ to saves the active file with its current file name, location, and file format.
(A) Ctrl + S
(B) Alt + S
(C) Ctrl + Alt + Esc
(D) Alt + Tab + Esc
Ans: A
Ctrl + S
Question: 10
Use the _____ to join, or concatenate, one or more text strings to produce a single piece of text.
(A) Ampersand
(B) Comma
(C) Colon
(D) Space
Ans: A
Ampersand