New MCQs MS Excel Queries Formula MCQs Solved
Sample Papers Must Prepare for NTS PTS OTS Jobs
Which of the following is an absolute cell reference?
- !A!1
- $A$1
- #a#1
- A1
- What symbol is used before a number to make it a label?
- “ (quote)
- = (equal)
- _ (underscore)
- ‘ (apostrophe)
- Which symbol must all formula begin with?
- =
- +
- (
- @
- Which of the following formulas is not entered correctly?
- =10+50
- =B7*B1
- =B7+14
- 10+50
- Which of the following formulas will Excel Not be able to calculate?
- =SUM(Sales)-A3
- =SUM(A1:A5)*.5
- =SUM(A1:A5)/(10-10)
- =SUM(A1:A5)-10
- A typical worksheet has …. Number of columns
- 128
- 256
- 512
- 1024
- How many characters can be typed in a single cell in Excel?
- 256
- 1024
- 32,000
- 65,535
- A worksheet can have a maximum of …. Number of rows
- 256
- 1024
- 32,000
- 65,535
- Which of the following is not an example of a value?
- 350
- May 10, 2001
- 57%
- Serial Number 50771
- The chart wizard term data series refers to
- A chart legend
- A collection of chart data markers
- A set of values you plot in a chart
- A data label
- The Chart wizard term data categories refers to;
- A chart plot area
- A horizontal axis
- The organization of individual values with a chart’s data series
- The data range that supply chart data
- A worksheet range is a
- A command used for data modeling
- A range of values such as from 23 to 234
- A group of cells
- A group of worksheets
- Getting data from a cell located in a different sheet is called …
- Accessing
- Referencing
- Updating
- Functioning
- Tab scrolling button
- Allow you to view a different worksheet
- Allow you to view additional worksheet rows down
- Allow you to view additional worksheet columns to the right
- Allow you to view additional sheets tabs
- A numeric value can be treated as a label value if it precedes with
- Apostrophe (&lsquo
- Exclamation (!)
- Hash (#)
- Ampersand (&
- Concatenation of text can be done using
- Apostrophe (&lsquo
- Exclamation (!)
- Hash (#)
- Ampersand (&
- Data can be arranged in a worksheet in a easy to understand manner using
- auto formatting
- applying styles
- changing fonts
- all of above
- You can use drag-and-drop to embed excel worksheet data in a word document
- By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key
- By dragging a range of excel data to the word button on the taskbar while pressing Shift key
- By dragging a range of excel data to the word button on the taskbar while pressing Alt key
- None of above
- The auto calculate feature
- Can only add values in a range of cells
- Provides a quick way to view the result of an arithmetic operation on a range of cells
- Automatically creates formulas and adds them to a worksheet
- A and c
- Excel uniquely identifies cells within a worksheet with a cell name
- Cell names
- Column numbers and row letters
- Column letters and row numbers
- Cell locator coordinates
New MCQs MS Excel Queries Formula MCQs Solved Sample Papers Must Prepare for NTS PTS OTS Jobs Google Ad Section
0 comments:
Post a Comment