Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Recent questions in MS Microsoft Excel skills
No documents found, press Enter to search
aaisha-masroor
about 8 years ago
MS Microsoft Excel skills
MS-Excel 2000 is a Windows based application package.
A spreadsheet is essentially a matrix of rows and columns.
Consider a sheet of paper on which horizontal and vertical lines are
drawn to yield a rectangular grid. The grid namely a cell, is the result
of the intersection of a row with a column. Such a structure is called a
Spreadsheet.
A spreadsheet package contains electronic equivalent of a pen,
an eraser and large sheet of paper with vertical and horizontal lines to
give rows and columns. The cursor position uniquely shown in dark
mode indicates where the pen is currently pointing. We can enter text
or numbers at any position on the worksheet. We can enter a formula
in a cell where we want to perform a calculation and results are to be
displayed. A powerful recalculation facility jumps into action each time
we update the cell contents with new data.
0
julian-delgado-14
over 1 year ago
MS Microsoft Excel skills
Quisiera saber una página de cursos de excel avanzado gratis
Si sabes déjame el link
1
dyanabel
over 6 years ago
MS Microsoft Excel skills
You are working with a large worksheet. Your row headings are in column A. Which command(s) should be used to see the row headings and the distant information in columns X, Y, and Z?
- a) Freeze Panes command
- b) New Window command and cascade the windows
- c) Hide Rows command
- d) Split Rows command
5
saqqi
over 6 years ago
MS Microsoft Excel skills
When using a spreadsheet, sum in the expression =Sum(B10:B16), is called a(n) ________.
- A) function
- B) operator
- C) formula
- D) operant
5
dhyaneshwar
over 6 years ago
MS Microsoft Excel skills
To go to column a of the current row, press ____.
- a. Home
- b. End
- c. Page Up
- d. Page Down
4
ekana
over 6 years ago
MS Microsoft Excel skills
One of the benefits of live preview is that it _____.
- a. Lets you see and evaluate different formats as you develop your workbook
- b. Shows you what a document will look like when printed
- c. Applies thematic styles to your document
- d. Allows you to track changes in your document
5
gajjbaahu
over 6 years ago
MS Microsoft Excel skills
mm/dd/yyyy is known as ____.
- a. Number data
- b. Text data
- c. A date format
- d. A text string
4
annapurna
over 6 years ago
MS Microsoft Excel skills
The fill handle copies ____.
- a. Content only
- b. Formats only
- c. Content and formats
- d. Formats and cell reference
4
taniaa
almost 7 years ago
MS Microsoft Excel skills
Function(argument1, argument2, ...) is ____.
- A. The syntax of writing optional arguments.
- B. An example of a formula
- C. The general syntax of all formulas
- D. The general syntax of all functions
4
shanee
almost 7 years ago
MS Microsoft Excel skills
“AZ” is an example of a ____.
- a. Column Heading
- b. Row Heading
- c. Cell Reference
- d. Name Box
4
techy
almost 7 years ago
MS Microsoft Excel skills
###### in a cell means that the ____.
- a. Formula contains an error
- b. Value contains an error
- c. Label has a spelling error
- d. Column is too narrow to display the value completely
4
dear-momo
almost 7 years ago
MS Microsoft Excel skills
A _____ indicates a manual page break.
- a) Solid red line
- b) Dashed red line
- c) Dashed blue line
- d) Solid blue line
4
nooor
almost 7 years ago
MS Microsoft Excel skills
A chart sheet can contain ____,enabling you to display several charts at once within a single sheet.
- a. Multiple Graphics
- b. Only one data set
- c. Only a single chart
- d. Embedded charts
4
MS Microsoft Excel skills