Introduction to excel online quiz
Description: introduction to excel | |
Number of Questions: 22 | |
Created by: Tanya Dwivedi | |
Tags: physics information communication technology (ict) |
The _______ is the arrangement of various flash elements, like panels, menus, bars, windows etc.
An application program that helps the user to change any number and immediately see the result of that change is
Asha was entering data into a worksheet and in the cell A$3$ she entered the formula $=A1+A2+A3$. What would be the result after pressing the Enter key?
Communication between computer and a keyboard involves.
The intersection of a column and row in a spreadsheet is called a bon of.
In a spreadsheet, a _______ is a number you will use in a calculation.
What would be the result of the given formula in MS-Excel $2010$, if cell A$1$ = $2016$?
= REPLACE (A$1, 3, 2, "17")$
Considering the given snapshot, where cells A$$: A$4$ has been named as "NUMBER" with the help of Define Name feature of MS-Excel $2010$. what would be the result of the given formula in MS-Excel $2010$?
= COUNT(NUMBER)
In table in excel, there are typical labels along with _________.
_________ is the short-key to move to the next worksheet.
To hide the columns ________ is the shortcut key.
__________ is the shortcut key to exit from excel.
__________ is the shortcut key used to select column.
To insert cells, rows or columns ________ the keyboard shortcut key.
___________ is the short-key to move to the previous worksheet.
___________ is the shortcut key used to select row.
__________ is the shortcut key to delete cells, rows or columns.
How many types of data can be entered in a worksheet?
How are data organized in a spreadsheet?
To check if data that is being entered does not have blanks, we have
The boxes that are displayed to indicate that the text pictures or objects are placed in it is called_________.