Showing posts with the label MS ExcelShow All

In MS Excel, how many columns are present in a worksheet?

9/21/2022 12:46:00 am

A. 250 B. 256 C. 306 D. 280 Answer Correct Answer: B. 256

In Microsoft Excel how many characters can be typed in a single cell?

9/21/2022 12:46:00 am

A. 1024 B. 2256 C. 32,767 D. 65,535 Answer Correct Answer: C. 32,76

The TRIM function is used for

1/21/2022 10:54:00 pm

A. changing the cases of the texts B. eliminating all empty spaces C. making italic te…

Ctrl + 5 puts the MS Excel

1/21/2022 10:54:00 pm

A. Underlines all cells in highlighted section B. Puts italics all cells in the highli…

COUNTA function in MS Excel

1/21/2022 10:53:00 pm

A. Counts all cells in a given range that contain numeric values and text values B. Co…

A Shortcut key which inserts hyperlink in MS Excel

1/21/2022 10:52:00 pm

A. Ctrl+ P B. Ctrl+ I C. Ctrl+ K D. Ctrl+ L

Ctrl + F searches in

1/21/2022 10:51:00 pm

A. Current sheet B. All Sheets C. Current Workbook D. All of above

A COUNT function in MS Excel

1/21/2022 10:50:00 pm

A. Counts all cells in a given range that contain numeric values and text values B. Su…

A ShortCut key to fill Content of the selected cell on top to bottom.

1/21/2022 10:50:00 pm

A. Ctrl+ V B. Ctrl + M C. Ctrl+ D D. All of above

A key to bold all cells in the highlighted section

1/21/2022 10:49:00 pm

A. Ctrl+A B. Ctrl+A+B C. Ctrl+B D. None of these

An AVERAGE Function is used in MS Excel for

1/21/2022 10:48:00 pm

A. To calculate the average B. To sum of rows C. To give the range of values D. All of…

What will happend if we do =SUM(B2:G2) ?

1/21/2022 10:47:00 pm

A. A simple selection that sums the values of a row. B. A simple selection that sums t…

What is difference between Formulas and Functions in MS Excel?

1/21/2022 10:46:00 pm

A. Formula is an expression B. Functions are predefined formulas C. A and B D. None of…

A key to open new workbook in MS Excel

1/21/2022 10:45:00 pm

A. Ctrl + N B. Ctrl+ B C. Ctrl+ W D. None of these

A ShortCut key to close the workbook in MS Excel

1/21/2022 10:44:00 pm

A. Ctrl+ C B. Ctrl+ W C. Ctrl+ X D. None of These

Shortcut key to copy text in MS Excel

1/21/2022 10:43:00 pm

A. Ctrl+ P B. Ctrl+ C C. Ctrl+ V D. All of above

Shortcut to underline a text in MS Excel

1/21/2022 10:43:00 pm

A. Ctrl+ P B. Ctrl+ B C. Ctrl+ U D. None of above

A key is used to edit current cell?

1/21/2022 10:42:00 pm

A. F1 B. F2 C. F5 D. F6