MS Excel Questions & Answers for Bank Exams 2020-2021 - 2

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

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

Question: 8

Pre-defined and built in formulas in Excel are known as

(A) Autosheets

(B) Charts

(C) Functions

(D) Tables

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

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