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:
- How to use the SUM function to calculate totals in Excel
- 7 time-saving tips when using Microsoft Excel
- How to use the COUNT function in Excel
You should read it
- Complete tutorial of Excel 2016 (Part 3): How to create and open existing spreadsheets
- Complete guide to Excel 2016 (Part 1): Get familiar with Microsoft Excel
- Guide to full Excel 2016 (Part 2): Learn about OneDrive
- Complete tutorial of Excel 2016 (Part 5): Basics of cells and ranges
- Guide to full Excel 2016 (Part 7): Format spreadsheet data
- Microsoft Excel test P5
- Complete guide to Excel 2016 (Part 13): Introduction to formulas
- A guide to the full Excel 2016 (Part 12): Page formatting and spreadsheet printing
May be interested
- Microsoft Excel Test P15tests 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 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 P9the 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 3the 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. 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 1sql 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 6in 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 5multiple-choice questions on sql help you familiarize and review useful knowledge for work and learning sql language.
- Common causes of Excel workbook errorslost 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 P13in 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.