Microsoft Excel Trivia Quiz Questions!
- 1.
The Shortcut keyborad for COPY ?
- A.
CTRL+V
- B.
CTRL+P
- C.
CTRL+C
- D.
CTRL+Z
Correct Answer
C. CTRL+CExplanation
The correct answer is CTRL+C. This shortcut key combination is commonly used to copy selected text or objects. By pressing CTRL+C, the selected content is copied to the clipboard, allowing users to paste it elsewhere using the CTRL+V shortcut. CTRL+P is used for printing, CTRL+V is used for pasting, and CTRL+Z is used for undoing the previous action.Rate this question:
-
- 2.
The shortcut keyborad to CUT text ?
- A.
CTRL+X
- B.
CTRL+C
- C.
CTRL+V
- D.
CTRL+B
Correct Answer
A. CTRL+XExplanation
The correct answer is CTRL+X. This shortcut key combination is commonly used to cut selected text or objects. Cutting text removes it from its original location and stores it in the clipboard, allowing it to be pasted elsewhere.Rate this question:
-
- 3.
The icon in red box is refer to
- A.
Show/Hide Formatting Marks
- B.
Formatting Text
- C.
Remove text effects
- D.
Format Painter
Correct Answer
A. Show/Hide Formatting MarksExplanation
The icon in the red box refers to the option of showing or hiding formatting marks. Formatting marks are special characters that are not normally visible in a document, but they represent formatting elements such as spaces, tabs, paragraph breaks, and more. By clicking on this icon, users can toggle the visibility of these formatting marks, allowing them to see and edit them as needed.Rate this question:
-
- 4.
The icon in red box is refer to
- A.
Adding text effects
- B.
Format Painter
- C.
Change Text Case
- D.
Remove text effects
Correct Answer
C. Change Text CaseExplanation
The icon in the red box refers to the "Change Text Case" function. This feature allows users to modify the capitalization of selected text, such as converting it to uppercase, lowercase, sentence case, or title case. By clicking on this icon, users can easily change the case of their text without having to manually retype or reformat it.Rate this question:
-
- 5.
The type of font
- A.
Arabstyle
- B.
Arial
- C.
Calibri (Body)
- D.
Calibri
Correct Answer
C. Calibri (Body)Explanation
The correct answer is Calibri (Body) because it is the only option that is a complete font name. The other options, Arabstyle, Arial, and Calibri, are incomplete or do not specify the font type. Therefore, Calibri (Body) is the correct answer as it provides a specific and complete font name.Rate this question:
-
- 6.
How many rows in this table ?
- A.
7
- B.
3
- C.
14
- D.
1
Correct Answer
B. 3Explanation
The correct answer is 3 because there are three rows in the table.Rate this question:
-
- 7.
The Direction of type
- A.
From right to left
- B.
From left to right
Correct Answer
A. From right to leftExplanation
The given answer states that the direction of the type is from right to left. This means that when reading or writing the type, it starts from the right side and moves towards the left side. This is a common direction of writing in languages such as Arabic and Hebrew. In these languages, the text is written and read from right to left, opposite to languages like English which are written and read from left to right.Rate this question:
-
- 8.
Size of font
- A.
34
- B.
48
- C.
4
- D.
72
Correct Answer
B. 48Explanation
The correct answer is 48 because it is the only option that represents a larger font size compared to the others. The other options (34, 4, and 72) are either smaller or larger than the given font size.Rate this question:
-
- 9.
In Microsoft Excel, which function can you use to conditionally sum values based on multiple criteria across different ranges?
- A.
SUM
- B.
SUMIF
- C.
SUMIFS
- D.
SUMPRODUCT
Correct Answer
C. SUMIFSExplanation
The SUMIFS function in Microsoft Excel is designed to sum values in a range based on one or more criteria across multiple ranges. Unlike SUMIF, which considers only a single condition, SUMIFS allows for multiple conditions. The function syntax is SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...), making it ideal for complex conditional summing where multiple criteria are to be met across different data columns. This makes it more versatile and powerful for detailed data analysis compared to SUM, SUMIF, and SUMPRODUCT, although SUMPRODUCT also allows for complex calculations and could be used similarly but requires different syntax and setup.Rate this question:
-
- 10.
How many number of sheet
- A.
1
- B.
4
- C.
566
- D.
3
Correct Answer
B. 4Explanation
The given answer is 4 because it is the only option that represents a numerical value. The other options are either incomplete or do not make sense in the context of the question. Therefore, the correct answer is 4.Rate this question:
-
- 11.
The type of view
- A.
Print layout
- B.
Drift view
- C.
Normal Niew
- D.
Full secreen Reading
Correct Answer
D. Full secreen ReadingExplanation
The correct answer is "Full screen Reading" because it is the only option that is spelled correctly and makes sense in the context of different types of views. The other options, "Print layout," "Drift view," and "Normal view," either have spelling errors or do not align with common types of views in a document or software application.Rate this question:
-
- 12.
The orientation apply in page
- A.
Portrait
- B.
Landscape
Correct Answer
B. LandscapeExplanation
The given answer "Landscape" suggests that the orientation being referred to is the orientation of a page. In the context of page orientation, "Landscape" refers to a horizontal orientation where the width of the page is greater than its height. This orientation is commonly used for documents or images that are wider than they are tall, such as spreadsheets or wide-angle photographs.Rate this question:
-
- 13.
The extension of any type of word
- A.
XLSX
- B.
PPX
- C.
DOCX
- D.
PUB
Correct Answer
C. DOCXExplanation
The correct answer is DOCX. DOCX is the file extension used for Microsoft Word documents in the newer versions of the software. XLSX is the file extension for Microsoft Excel documents, PPX is not a recognized file extension, and PUB is the file extension for Microsoft Publisher documents. Therefore, DOCX is the correct answer as it represents the file extension for a type of word document.Rate this question:
-
- 14.
When typing text in word you should press ENTER at the end of a: When typing text in word you should press ENTER at the end of a:
- A.
Line
- B.
Page
- C.
Paragraph
- D.
Document
Correct Answer
C. ParagrapHExplanation
When typing text in Word, you should press ENTER at the end of a paragraph. This is because pressing ENTER creates a new paragraph, which is a distinct block of text separated by a blank line. Pressing ENTER at the end of a line or page does not create a new paragraph, but rather a line break or page break respectively. Similarly, pressing ENTER at the end of a document would not create a new paragraph, as there would be no additional text to separate.Rate this question:
-
- 15.
To select a single word :
- A.
Press F8 three times
- B.
Press CTRL and click the word
- C.
Press CTRL + W
- D.
Double click the word
Correct Answer
D. Double click the wordExplanation
Double clicking the word is the correct answer because it is a common action used to select a single word. By quickly clicking the left mouse button twice, the word is highlighted and selected. This method is widely used and easily accessible, making it a convenient way to select a single word.Rate this question:
-
- 16.
Which tab would you choose to change the font size of a word from 12 points to 18 points?
- A.
File
- B.
Home
- C.
Insert
- D.
Page Layout
Correct Answer
B. HomeExplanation
To change the font size of a word from 12 points to 18 points, you would choose the "Home" tab. The "Home" tab is typically where you can find formatting options such as font size, font style, and font color. By selecting the "Home" tab, you can easily locate the font size option and adjust it to the desired 18 points.Rate this question:
-
- 17.
If you want to add a table to your document, which tab would you choose?
- A.
File
- B.
Home
- C.
Insert
- D.
Save
Correct Answer
C. InsertExplanation
If you want to add a table to your document, you would choose the "Insert" tab. This tab typically contains various options for inserting different types of objects, such as tables, pictures, shapes, and charts. So, selecting the "Insert" tab would provide you with the necessary tools and options to add a table to your document.Rate this question:
-
- 18.
You insert a clip art and it is too big. To resize it you would.
- A.
Change it the same way you change the font size
- B.
Click the insert tab and choose resize
- C.
Click the Home tab and choose resize
- D.
Click on the clip art to show the handles anddrag a handle to resize it
Correct Answer
D. Click on the clip art to show the handles anddrag a handle to resize itExplanation
To resize a clip art that is too big, you need to click on the clip art to show the handles and then drag a handle to resize it. This allows you to manually adjust the size of the clip art according to your preference.Rate this question:
-
- 19.
The format of the active part of the document is :
- A.
Page 1 , Sec 1 , 1/1
- B.
Normal , Times New Roman , size 14
- C.
Normal , Times New Roman , size 12
- D.
A+B
Correct Answer
C. Normal , Times New Roman , size 12Explanation
The given correct answer is "Normal, Times New Roman, size 12". This is because the active part of the document is described as being in "Normal" format, which typically refers to the default formatting style. The font style is specified as "Times New Roman" and the font size is specified as "12".Rate this question:
-
- 20.
The name of the document is:
- A.
Computer Skills.doc
- B.
Computer Skills
- C.
Computer Skills.pdf
- D.
Computer Skills.dox
Correct Answer
D. Computer Skills.doxExplanation
The correct answer is "Computer Skills.dox" because the file extension ".dox" suggests that the document is a Microsoft Word file. The other options have file extensions that indicate different file formats, such as ".doc" for a Word document, ".pdf" for a PDF file, and no file extension for a plain text file.Rate this question:
-
- 21.
The total number of rows in microsoft excel
- A.
24
- B.
1,048,576
- C.
16,384
- D.
155
Correct Answer
B. 1,048,576Explanation
Microsoft Excel has a maximum limit of 1,048,576 rows. This means that you can have up to 1,048,576 rows of data in a single worksheet. This allows for a large amount of data to be stored and analyzed in Excel, making it a powerful tool for data management and analysis. With this many rows available, Excel can handle large datasets and complex calculations efficiently.Rate this question:
-
- 22.
The Range Is select
- A.
1 cell
- B.
2 cell
- C.
5 cell
- D.
None OF Above
Correct Answer
D. None OF AboveExplanation
The given options suggest different ranges, such as 1 cell, 2 cells, and 5 cells. However, the correct answer states "None OF Above," indicating that none of the provided options accurately represent the range. Therefore, the correct answer is none of the above.Rate this question:
-
- 23.
How many rows we select
- A.
3 x 3
- B.
3
- C.
6
- D.
4
Correct Answer
B. 3Explanation
The correct answer is 3 because the question is asking how many rows we select, and out of the given options (3 x 3, 3, 6, 4), only the number 3 represents the number of rows. The other options are either multiplication or unrelated numbers.Rate this question:
-
- 24.
If you see pound signs (#######) in a cell, it means
- A.
The row is very height
- B.
The column is very width
- C.
The number of cell is larg
- D.
The column is not wide enough to display the cell content
Correct Answer
D. The column is not wide enough to display the cell contentExplanation
The correct answer is that the column is not wide enough to display the cell content. When you see pound signs (#######) in a cell, it indicates that the column width is not sufficient to show the complete content of the cell. This typically happens when the content of the cell is too long or when the column width is manually adjusted to be too narrow. To fix this, you can either widen the column or adjust the cell content to fit within the current column width.Rate this question:
-
- 25.
To unhide a column we
- A.
Select the columns on Before side of the hidden column
- B.
Select the columns on between side of the hidden column
- C.
Select the columns on either side of the hidden column
- D.
Select the columns on Top side of the hidden column
Correct Answer
C. Select the columns on either side of the hidden columnExplanation
To unhide a column, we need to select the columns on either side of the hidden column. This means that we need to select the columns that are adjacent to the hidden column, on both sides. By selecting these columns, we can then unhide the hidden column and make it visible again.Rate this question:
-
- 26.
The Type of This Chart is
- A.
Column
- B.
Line
- C.
Pie
- D.
Par
Correct Answer
A. ColumnExplanation
The correct answer is column because a column chart is a type of chart that uses vertical bars to represent data. Each bar represents a category, and the height of the bar corresponds to the value of that category. This type of chart is commonly used to compare different categories or show changes over time.Rate this question:
-
- 27.
The type of this chart is
- A.
Column
- B.
Pie
- C.
Line
- D.
Par
Correct Answer
B. PieExplanation
The correct answer is pie because a pie chart is a circular statistical graphic that is divided into slices to represent the proportion of different categories in a data set. It is commonly used to show the distribution of data and the relationship between parts and the whole.Rate this question:
-
- 28.
In Excel the intersection of a column and a row is called :
- A.
Range
- B.
Block
- C.
Selection
- D.
Cell
Correct Answer
D. CellExplanation
In Excel, the intersection of a column and a row is referred to as a "cell". A cell is the smallest unit in a spreadsheet where data can be entered, edited, and manipulated. It is identified by a unique combination of a column letter and a row number. Cells can contain various types of data such as text, numbers, formulas, and functions. They are used to organize and store information in a structured manner, allowing for easy analysis and calculation.Rate this question:
-
- 29.
What is the shorter way of computing =C1+C2+C3+C4+C5+C6+C7+C8 ?
- A.
TOTAL (C1:C8)
- B.
AVERAGE (C1:C8)
- C.
SUM (C1:C8)
- D.
COUNT (C1:C8)
Correct Answer
C. SUM (C1:C8)Explanation
The correct answer is "SUM (C1:C8)". This function calculates the sum of the values in the range C1 to C8. By using this function, you can quickly find the total of the values in these cells without having to manually add them up individually.Rate this question:
-
- 30.
On a Chart, what is used to indicate what each color or symbol stands for ?
- A.
A data series
- B.
The X-axis
- C.
Legend
- D.
A category
Correct Answer
C. LegendExplanation
A legend is used on a chart to indicate what each color or symbol stands for. It provides a key or explanation for the different elements used in the chart, allowing the reader to understand the meaning behind the colors or symbols used. This helps in interpreting the data accurately and making informed conclusions from the chart.Rate this question:
-
- 31.
Writing an incorrect formula that attempts to perform math by referring to a text entry causes excel to display what in the formula cell ?
- A.
ERROR
- B.
#VALUE
- C.
#####
- D.
D.!!!!!
Correct Answer
B. #VALUEExplanation
When writing an incorrect formula that tries to perform math by referencing a text entry, Excel will display the error message "#VALUE" in the formula cell. This error occurs because Excel cannot perform mathematical operations on text values.Rate this question:
-
- 32.
How many cells are included in the range A1:B3?
- A.
2
- B.
9
- C.
8
- D.
6
Correct Answer
D. 6Explanation
The range A1:B3 includes a total of 6 cells. This is because it includes 3 rows and 2 columns, resulting in a total of 6 cells.Rate this question:
-
- 33.
Cell A4 =2 and A5 = 4. You select both cells and drag the fill handle down to A8. The contents of cells A6, A7, and A8 are
- A.
8,16,32
- B.
2, 4, 2
- C.
2, 2, 2
- D.
6,8,10
Correct Answer
D. 6,8,10Explanation
When you select cells A4 and A5 and drag the fill handle down to A8, the fill handle will automatically fill the cells with a series based on the pattern it detects. In this case, the pattern is doubling the value in each cell. So, the contents of cells A6, A7, and A8 will be 6, 8, and 10 respectively, as they are the result of doubling the values in A5 (4).Rate this question:
-
- 34.
The formula that will add the value of cell D4 to the value of C2 and then multiply by the value in B2 is:
- A.
D4+C2*B2
- B.
= (D4+C2*B2
- C.
(D4+C2)*B2
- D.
(B2*(D4+C2)
Correct Answer
C. (D4+C2)*B2Explanation
The correct answer is (D4+C2)*B2. This formula correctly adds the value of cell D4 to the value of C2 and then multiplies it by the value in B2. The parentheses ensure that the addition is performed before the multiplication, which follows the order of operations in mathematics.Rate this question:
-
- 35.
Resulting from this equation
- A.
0
- B.
777
- C.
10001
- D.
1000
Correct Answer
C. 10001 -
- 36.
Resulting from this equation
- A.
4
- B.
1000
- C.
777
- D.
0
Correct Answer
D. 0Explanation
The given equation is not provided, so it is not possible to determine the resulting value from the equation. Therefore, an explanation for the answer is not available.Rate this question:
-
- 37.
Resulting from this equation
- A.
84
- B.
80
- C.
85
- D.
86
Correct Answer
C. 85 -
- 38.
Resulting from this ( IF )equation
- A.
B2=B3
- B.
8=99
- C.
DIV BY ZERO
- D.
NON Of Above
Correct Answer
C. DIV BY ZEROExplanation
The equation B2 = B3 is stating that the value of B2 is equal to the value of B3. However, the equation 8 = 99 is false and does not make sense. Additionally, dividing by zero is undefined and not possible in mathematics. Therefore, the correct answer is "DIV BY ZERO" as it accurately identifies the error in the equation.Rate this question:
-
- 39.
Resulting from this equation
- A.
9
- B.
22
- C.
8
- D.
8/99
Correct Answer
C. 8 -
- 40.
Resulting from this (IF) equation
- A.
A2/A3
- B.
" DEV BY ZERO "
- C.
DEV BY ZERO
- D.
66
Correct Answer
C. DEV BY ZEROExplanation
The given equation A2/A3 indicates a division operation, where A2 is divided by A3. However, the result of this division is undefined or "DEV BY ZERO" because dividing any number by zero is mathematically undefined. Therefore, the answer is "DEV BY ZERO".Rate this question:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Apr 28, 2024Quiz Edited by
ProProfs Editorial Team -
Nov 28, 2018Quiz Created by
Ahmad
Back to top