The default header for a worksheet is


Options: Username B. Date and Time C. Sheet tab Name D. None

Ans:– D ,


Description: Its like Book1 -Microsoft Excel

Asked in: KCC-2018   |   JOA 556-2018  |  HRTC JTO-2017

Hits Today: 19532 | Level: Moderate


******************************************************

Want to see where do you stand among other aspirants in "Computer" category?

Click Here to take quick 10 mins MCQ test to find out.




Got some suggestion about this question or to make this site better? Please leave your comments below.




More MS-Excel Related questions:


A system program that combines the separately compiled modules of a program into a form suitable for execution
Options: assembler,    linking loader,    cross compiler,    load and go

Ans:B ,B


What is the usual number of bits transmitted simultaneously in parallel data transmission used by microcomputers?
Options: 16,    9,    8,    4

Ans:B ,B


Which of the following data structure is linear data structure?
Options: a. Trees b. Graphs c. Arrays d. None of above  

Ans:c,c


Which of the following special shell variables is used to process number of the current shell?
Options: $!,    $$,    $0,    $*

Ans:B ,B


Which of the following is still useful for adding numbers?
Options: EDSAC,    ENIAC,    Abacus,    UNIVAC

Ans:C,(Canswer


. Which function extracts the name of the month from a date/time value?
Options: a. Month b. MonthName c. MonthLabel d. MonthValue

Ans:1 – b ,1 – b


Which of the following SQL statements are helpful in database redesign?
Options: Correlated subqueries only,    EXISTS/NOT EXISTS expressions only,    Both of the above are helpful,    None of the above are helpful.

Ans:C ,C


A command that lets you change one or more fields in a record is
Options: a. insert b. modify c. lookup d. none of above 

Ans:.b,.b


Positive testing is
Options: running the system with line data by the actual user,    making sure that the new programs do in fact process certain transactions according to Specifications,    is checking the logic of one or more programs in the candidate system,    testing changes made in an existing or a new program

Ans:B ,B


. The contents of information are stored in
Options: A) Memory data register B) Memory address register C) Memory arithmetic registers D) Memory access register

Ans:3-A,3-A


Which of the following statement is true
Options: a. Reports can be used to retrieve data from tables and calculate b. Queries can be printed in well formatted manner and presented as the information c. Queries can include calculated fields that do not exist in table d. Reports and forms are similar but forms are use to print but reports to display on screen only

Ans:ndash; c,ndash; c


. ______ shares characteristics with both hardware and software
Options: a. Operating system b. Software c. Data d. None

Ans:4 – a ,4 – a


. You can merge the main document with data source in Excel. In mail merge operation, Word is usually
Options: a.  server b.  source c.  client d.  none

Ans:– c,– c


The formula for memory capacity is:
Options: MC = N/2,    MC = 2/N,    MC = N squared.,    MC -2 to the Nth power

Ans:D ,D


What are the IRQ's for sound card?
Options: IRQ8,    IRQ4,    IRQ5,    IRQ7

Ans:C ,C


To return the remainder after a number is divided by a divisor in EXCEL we use the function?
Options: ROUND ( ) B. FACT ( ) C. MOD ( ) D. DIV ( )

Ans:– C ,


Which of the following is not a type of relationship that can be applied in Access database
Options: a. One to One b. One to Many c. Many to Many d. All of above can be applied

Ans:ndash; d,ndash; d


When the minimum and maximum number of instances of an entity is one, you know which of the following?
Options: Mandatory one,    Optional one,    Mandatory many,    Cannot tell

Ans:A ,A


. Poor response time are usually caused by
Options: a. Process busy b. High I/I rates c. High paging rate d. Any of the above

Ans:9 – d ,9 – d


The ODBC Level 2 API contains which the following functions?
Options: Commit or rollback transactions only,    Connect to data sources with driver-specific information only,    Connect to data sources only,    All of the above are contained in the OBDC Level 2 API

Ans:D ,D


The ASCII code for the character J is:
Options: 1001 0001,    1001 1010,    0100 1010,    1010 0001

Ans:C ,C


Which of the following is not a limitation of binary search algorithm?
Options: a. must use a sorted array b. requirement of sorted array is expensive when a lot of insertion and deletions are needed c. there must be a mechanism to access middle element directly d. binary search algorithm is not efficient when the data elements are more than 1000.

Ans:- d,- d


. Which of the following magazines covers only the IBM PC and its compatibles?

Options: A) Byte B) PC Magazine C) Personal Computing D) Interface Age

Ans:B,B


The Software which contains rows and columns is called ______
Options: Database B. Drawing C. Spreadsheet D. Word processing

Ans:– C ,


84. Which feature do you use to create a newspaper like document?
Options: a. Bullets & numbering b. Tables c. Columns d. Tab stops

Ans:–  C ,–  C


RPM
Options: stands for Red Hat Package Manager,    is used to install, uninstall, and manage packages,    is used to keep track of the users,    assigns a dynamic IP address

Ans:A ,A


An important first step in troubleshooting which component in a laser printer is causing a jam is to:
Options: note where in the paper path the paper stops,    check all voltages,    look up error codes,    turn the printer off, then on again

Ans:A ,A


.   PowerPoint can display data from which of the following add-in software of MS-Office
Options: a. Equation editor b. Organization chart c. Photo album d. All of these

Ans:5 – D ,5 – D


. Which types of charts can excel produce?
Options: a. Line graphs and pie charts only b. Only line graphs c. Bar charts, line graphs and pie charts d. Bar charts and line graphs only

Ans:– c,– c


Which computer has been designed to be as compact as possible?
Options: Mini,    Super computer,    Micro computer,    Mainframe

Ans:C ,C


What is the maximum distance with maximum data rate for 802.11a?
Options: About 65-75 feet,    About 90-100 feet,    About 150 feet,    Over 200 feet

Ans:A ,A


. From where do you change mouse setting?
Options: a. Setting >> mouse b. Hardware setting c. Control panel >> mouse d. None of the above

Ans:1 – c ,1 – c


. The meaning of Straight-through Cable is
Options: Four wire pairs connect to the same pin on each end B. The cable Which Directly connects Computer to Computer C. Four wire pairs not twisted with each other D. The cable which is not twisted

Ans: – A ,


A typical worksheet has …. Number of columns
Options: a. 128 b. 256 c. 512 d. 1024

Ans:#8211; b,#8211; b


. Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following?
Options: a. Rows and columns b. Headings c. Speed d. None

Ans:– c,– c


Which enables us to send the same letter to different persons?
Options: a. macros b. template c. mail merge d. none

Ans:–  C,–  C


What is the first octet range for a class A IP address?
Options: 1 - 126,    192 - 255,    192 - 223,    1 - 127

Ans:A ,A


. What you type at the DOS command prompt to return back to windows?
Options: a. Command b. Exit c. Quit d. Return

Ans:6 – b ,6 – b


. While working with MS DOS which command is used to change the extension of all file names ending with .txt to doc?
Options: a. Ren *.doc *.txt b. Ren .txt .doc c. Ren file.doc file.text d. Ren a:*.doc *.doc

Ans:6 – a ,6 – a


All the instructions and procedures needed to start up a computer, to the point it can load an operating system, are stored in ROM chips. In IBM compatible PCs this is called the _____
Options: RAM BIOS,    ROM BIOS,    EPROM,    POST

Ans:B,B


The first step of the implementation phase is
Options: select the computer,    announce the implementation project,    implementation planning,    prepare physical facilities

Ans:C ,C


Which of the following tool allows you to change your default X Window desktop?
Options: switchdesk,    intrc,    xinitre,    Xchange

Ans:A ,A


How many DMA channels are there in an AT class PC?
Options: 3,    4,    7,    8

Ans:D ,D


. The notable features like keyboards, monitors, GUI were developed in
Options: A) First generation B) Second generation C) Third generation D) Fourth generation

Ans:C,C


An input device that converts data punched into paper lape into a binary format is
Options: Page reader,    Paper tape punch,    Paper tape reader,    Card punch

Ans:C ,C


. One computer that is not considered a portable is
Options: A) Minicomputer B) Laptop computer C) Notebook computer D) All of above

Ans:A,A


. What is the first stage in software development?
Options: A) Specification and design B) Testing C) System Analysis D) Maintenance

Ans:C,C


What is the main communication method from one PDA to another PDA?
Options: IR,    USB,    RS-232,    IEEE 1394

Ans:A ,A


What is the first octet range for a class B IP address?
Options: 128 - 255,    1 - 127,    192 - 223,    128 - 191

Ans:D ,D


Which daemon is used for the Apache server?
Options: apached,    httpd,    html,    shttp

Ans:B ,B

www.000webhost.com