Test your understanding of Excel

Excel is one of the basic Microsoft Office applications that anyone who uses computers knows. Excel has many useful software for users to use, such as software to support writing, presentations, managing email or spreadsheets like Excel. This software helps create spreadsheets, with features, tools to support users to calculate data quickly and accurately with the number of millions of cells. In the article below, Network Administrator will send you more useful information about Excel software through the following quiz.

Question 1 . How to start Excel?

A. Click on the Start button, point to All Programs and select Microsoft Excel
B. Click on the Word icon on the Desktop screen
C. Click on the Start button, point to All Programs and select Microsoft Word
D. Click on the Start button, point to Settings and select Microsoft Excel

Question 2 . Is it possible to save spreadsheets on a computer using a key combination?

A. Ctrl + S
B. Shift + S
C. Ctrl + O
D. Shift + O

Question 3 . If you select multiple blocks simultaneously, select the first block and press which key to select the next block?

A. Alt
B. Ctrl
C. Shift
D. Any key is fine

Question 4 . Symbols of multiplication and division in spreadsheet programs denote:

A. Sign. and:
B. Sign. and /
C. * and:
D. * and /

Question 5 . By default, numeric data is aligned:

A. Left
B. Right
C. Between
D. Both sides

Question 6 . Where you can enter Excel formulas

A. Title bar
B. Formula bar
C. Toolbar
D. Namebox
E. Menu bar

Question 7 . If A1 = 30, A2 = 20. The formula used to multiply these numbers and write the value to cell C6 is:

A. C6 = Multiply A1: A2
B. C6 = A1 * A2
C. C6 = Multiply A1 to A2
D. C6 = 30 * 20

Question 8 . Excel files are usually saved with extensions:

EAT RICE
B. EXE
C. XLS
D. PST

Question 9 . You need to sum C5 to C70, which of the following is correct?

A. C5 + C6 + C7 + .
B. Add C5: C70
C. Add C5 to C70
D. SUM (C5: C70)

Question 10 . Which of the following characters is only an addition in Excel

A. +
B. -
C. *
D. /

Question 11 Available data is entered in the box:

A. Active Cell
B. Current Cell
C. Ofdet Cell
D. Format Cell

Question 12 To copy the format in Excel we use:

A. Format Cell
B. Format Painter
C. Enter key
D. Del key

Question 13 . In Excel, the formula in 1 Cell always starts with:

A. Caps
B. Question mark
C. Equal sign
D. Signed

Verse 14 . Any Excel version does not support the XLSM format

A. Excel 2013 version
B. Excel 2003 version
C. Excel 2007 version
D. Excel 2016 version

Question 15 . The shortcut key combination used to open the Format Cells dialog box is:

A. CTRL + X
B. CTRL + L
C. CTRL + 1
D. CTRL + F

Answer:

1. A

2 A

3. D

4. D

5. B

6. B

7. B

8. C

9. D

10. A

11. A

12. B

13. C

14. B

15. C

See more:

  1. How to use the SUM function to calculate totals in Excel
  2. 7 time-saving tips when using Microsoft Excel
  3. How to use the COUNT function in Excel
4 ★ | 1 Vote

May be interested

  • Microsoft Excel Test P15Microsoft Excel Test P15
    tests on excel help you test your basic knowledge. please try your knowledge with the following questions that the network administrator has edited.
  • Microsoft Excel Test P10Microsoft Excel Test P10
    microsoft excel is a great software or application program, but when you run this application, it creates a spreadsheet and spreadsheet that makes it easier to perform calculations or tabulate. .. below, invite readers to test their knowledge with the multiple choice questions below on this topic.
  • Microsoft Excel Test P9Microsoft Excel Test P9
    the following network administrator will send you to read multiple choice questions about excel, invite you to test your knowledge. the set of questions consists of 10 sentences, 4 answers each to choose from.
  • [QUIZ] Test your understanding of SQL - Part 3[QUIZ] Test your understanding of SQL - Part 3
    the test set comes with sql lessons that give you lots of useful knowledge.
  • CHISQ.TEST function - The function returns the independence test in ExcelCHISQ.TEST function - The function returns the independence test in Excel
    chisq.test function: the function returns the independence test. the function returns the value from the distribution (({chi ^ 2})) when squared for statistics and the appropriate degrees of freedom. support function from excel 2010 version. syntax: chisq.test (actual_range, expected_range)
  • [QUIZ] Test your understanding of SQL - Part 1[QUIZ] Test your understanding of SQL - Part 1
    sql is a familiar term if you pay attention to the computer field. so what do you know about sql?
  • [QUIZ] Test your understanding of SQL - Part 6[QUIZ] Test your understanding of SQL - Part 6
    in order to serve your work and your study, along with sql lessons, quantrimang offers a variety of useful questions.
  • [QUIZ] Test your understanding of SQL - Part 5[QUIZ] Test your understanding of SQL - Part 5
    multiple-choice questions on sql help you familiarize and review useful knowledge for work and learning sql language.
  • Common causes of Excel workbook errorsCommon causes of Excel workbook errors
    lost your work on excel due to file corruption? understanding the errors that cause damaged excel files will help you avoid that from happening.
  • Test Microsoft Excel P13Test Microsoft Excel P13
    in this article, network administrators will continue to learn about excel software through extremely interesting multiple-choice questions below. try to see how many questions you will make.