The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Microsoft word is one of the most used Microsoft applications, and you cannot claim to know anything about using a computer and not know a thing or two about Microsoft word. Are you looking for a way to test out your basic skills on this application? Take up the quiz below and get to see if you can tackle it. All the best of luck!
Questions and Answers
1.
The process of turning the system on is called?
A.
Oning
B.
Starting
C.
Booting
D.
Hard start
Correct Answer C. Booting
Explanation The process of turning the system on is commonly referred to as "booting". This term originated from the phrase "pulling oneself up by the bootstraps", which signifies starting a system with minimal external help. During the booting process, the system's hardware is initialized, and the operating system is loaded into the computer's memory. Therefore, "booting" is the correct term for starting up a system.
Rate this question:
2.
What is not a basic part of a spreadsheet?
A.
Formula
B.
Cell
C.
Row
D.
Column
Correct Answer A. Formula
Explanation A formula is not a basic part of a spreadsheet. While cells, rows, and columns are fundamental components of a spreadsheet, a formula is a specific function or equation that is used to perform calculations or manipulate data within the spreadsheet. Formulas are created by using mathematical operators, functions, and cell references to perform calculations or automate tasks. They allow users to perform complex calculations and analysis within a spreadsheet.
Rate this question:
3.
Which of the following is not an input device?
A.
Laptop
B.
VDU
C.
UPS
D.
Mouse
Correct Answer D. Mouse
Explanation The mouse is not an input device because it is actually an output device. It is used to control the cursor on the screen and interact with graphical user interfaces, making it an output device rather than an input device.
Rate this question:
4.
In a spreadsheet, the ________ is defined as the horizontal space that is going across the window.
Correct Answer Rows rows Row row
Explanation The correct answer is "rows". In a spreadsheet, rows are defined as the horizontal space that goes across the window. Rows are used to organize and display data horizontally, allowing users to input and manipulate information in a structured manner. By selecting and manipulating rows, users can perform various operations such as sorting, filtering, and formatting data in a spreadsheet.
Rate this question:
5.
In a spreadsheet, the __________ is defined as the vertical space that is going across the window.
Correct Answer Column column Columns Column
Explanation The correct answer is "Column". In a spreadsheet, a column refers to the vertical space that runs across the window. It is used to organize and categorize data in a tabular format. Multiple columns can be created to represent different variables or attributes of the data being analyzed.
Rate this question:
6.
_____________ are used to designate each column's location.
Correct Answer Letters Letter letters letter
Explanation The words "Letters," "Letter," "letters," and "letter" are all used to designate each column's location. These words are all synonyms and can be used interchangeably in this context.
Rate this question:
7.
___________ are used to designate each row's location.
Correct Answer Numbers Number numbers number
Explanation The correct answer is "Numbers, Number, numbers, number". In this context, the word "numbers" refers to multiple rows, while "Number" refers to a singular row. The lowercase versions "numbers" and "number" are used as alternatives to the capitalized versions. Therefore, all of these options can be used to designate each row's location.
Rate this question:
8.
In a spreadsheet, the ___________ is defined as the space where a specified row and column intersect.
A.
Labels
B.
Cell
C.
Formulas
D.
Numbers
Correct Answer B. Cell
Explanation A cell in a spreadsheet is the space where a specified row and column intersect. It is the basic unit of a spreadsheet and can contain labels, formulas, or numbers.
Rate this question:
9.
Name this cell:
Correct Answer B6 b6
Explanation The correct answer is B6,b6 because the question is asking for the name of a cell, and B6 and b6 are both valid names for a cell. In Excel, cells can be named using a combination of letters and numbers, and they are not case-sensitive. Therefore, both B6 and b6 can be used as names for the cell.
Rate this question:
10.
In the spreadsheet below, provide an example of a label?
Correct Answer computer ledger car loan interest # of payments Monthly Pmt.
Explanation The given options "computer ledger, car loan, interest, # of payments, Monthly Pmt." are all examples of labels. In a spreadsheet, labels are used to identify and categorize data or information. These labels help to organize and make the data more understandable and accessible.
Rate this question:
11.
True or False: Labels do not have a value associated with them
A.
True
B.
False
Correct Answer A. True
Explanation Labels in programming do not have a value associated with them. They are used as markers or identifiers to indicate a specific location in the code. Labels are commonly used in loops or conditional statements to control the flow of the program. Unlike variables or constants, labels do not store any data or have any assigned value. Therefore, the statement "Labels do not have a value associated with them" is true.
Rate this question:
12.
True or False: Constants are entires that do not have a specified value
A.
True
B.
False
Correct Answer B. False
Explanation Constants are entries that have a specified value and cannot be changed during the execution of a program. Unlike variables, constants have a fixed value that remains constant throughout the program. Therefore, the correct answer is False, as constants do have a specified value.
Rate this question:
13.
In the spreadsheet below, provide an example of a constant:
Correct Answer $12,000.00 9.60% 60
Explanation The given answer provides three examples of constants: $12,000.00, 9.60%, and 60. A constant is a value that does not change and remains the same throughout a calculation or analysis. In this case, $12,000.00 represents a fixed monetary amount, 9.60% represents a fixed interest rate, and 60 represents a fixed number of units. These values are not variables and do not vary in the given context.
Rate this question:
14.
All formulas must begin with what?
Correct Answer =
Explanation All formulas must begin with the equal sign (=) in order to indicate that a calculation or equation is being entered. This is a standard convention in most spreadsheet programs, such as Microsoft Excel or Google Sheets, where formulas are commonly used to perform calculations and manipulate data. The equal sign acts as a signal to the program that the following characters should be interpreted as a formula rather than regular text.
Rate this question:
15.
____________ are entires that have equations that calculates the value to display.
n
A.
Labels
B.
Constants
C.
Spreadsheet
D.
Formulas
Correct Answer D. Formulas
Explanation Formulas are entries that have equations that calculate the value to display. In a spreadsheet or any other data entry system, formulas are used to perform calculations based on the data entered in other cells. These calculations can involve mathematical operations, functions, and references to other cells. By using formulas, users can automate calculations and update the results automatically whenever the input data changes.
Rate this question:
16.
Provide the formula for the following spreadsheet: If you work for 23 hours and make $5.36 an hour, how much do you make?
Correct Answer =B1*B2 =b1*b2
Explanation The formula "=B1*B2" and "=b1*b2" are both correct because they represent the multiplication of the values in cell B1 (which represents the number of hours worked) and cell B2 (which represents the hourly rate). This multiplication will give the total amount earned. The formula is case-insensitive, so both uppercase and lowercase letters can be used.
Rate this question:
17.
The ___________ function takes all of the values in each of the specified cells and totals their values
Correct Answer SUM sum
Explanation The "SUM" function is used to add up all the values in the specified cells and provide the total sum. The function is case-insensitive, so it can be written as "sum" as well. Both "SUM" and "sum" will perform the same task of totaling the values in the specified cells.
Rate this question:
18.
The _________ function adds all of the indicated cells together and divides by the total number of cells.
Correct Answer Average average
Explanation The average function is used to calculate the mean value of a set of numbers. In this case, it adds all the indicated cells together and then divides the sum by the total number of cells.
Rate this question:
19.
The two most widely used charts are the:
Correct Answer bar
Explanation The given answer "bar" is correct because the question states that the two most widely used charts are being referred to, and "bar" is one of the most commonly used chart types. Bar charts are effective for comparing data across different categories or groups, as they display data as rectangular bars with lengths proportional to the values they represent. They are widely used in various fields such as statistics, economics, and business to present and analyze data visually.
Rate this question:
20.
Name the three basic parts of a spreadsheet?
Correct Answer rows columns cells
Explanation The three basic parts of a spreadsheet are rows, columns, and cells. Rows are horizontal lines that run across the spreadsheet, while columns are vertical lines that run down the spreadsheet. Cells are the individual boxes formed by the intersection of rows and columns, where data can be entered and manipulated. These three components are essential for organizing and analyzing data in a spreadsheet.
Rate this question:
21.
In a spreadsheet, each cell may have three types of data in them: Name all three
Correct Answer constants labels formulas
Explanation In a spreadsheet, each cell can contain three types of data: constants, labels, and formulas. Constants are values that do not change and are manually entered into the cell. Labels are used for text or titles to provide descriptions or headings within the spreadsheet. Formulas are used to perform calculations and manipulate data based on the values in other cells.
Rate this question:
22.
What is the symbol for multiplication?
Correct Answer *
Explanation The symbol for multiplication is represented by an asterisk (*). This symbol is commonly used in mathematical equations and calculations to denote the operation of multiplication. It is a widely recognized symbol that indicates the multiplication of two or more numbers.
Rate this question:
23.
What is the symbol for division?
Correct Answer /
Explanation The symbol "/" is commonly used to represent division in mathematical equations. It indicates the operation of dividing one number by another to find the quotient. This symbol is widely recognized and used in various mathematical contexts, such as arithmetic, algebra, and calculus.
Rate this question:
24.
What is the symbol for addition?
Correct Answer +
Explanation The symbol "+" is used to represent addition in mathematics. It is a common symbol that is universally recognized and understood to mean the operation of adding two or more numbers together. The horizontal line represents the joining of the numbers, indicating that they are being combined to find a total or sum.
Rate this question:
25.
What is the symbol for subtraction?
Correct Answer -
Explanation The symbol "-" is used to represent subtraction in mathematics. It is commonly known as the minus sign. When placed between two numbers, it indicates that the second number should be subtracted from the first. For example, in the expression 5 - 3, the minus sign represents subtraction and the answer is 2.